Conditional Format - new

[Conditional]

I am using the conditional formatting option to make all
cells that are below a cell with a similar value be blank,
or more precisely, white. However, I would also like to
have the fill in the rows alternate between white and gray
for style appearances, thus making the conditional format
output be white if the background fill is white and gray
if the background fill is gray. However, there does not
appear to be an option that allows for conditional
formatting based on the cell format, rather it is based
off of cell content.

Is there a way to make my styling preference happen
without too much effort?

 

[Frank Kabel]

Hi
you could use two conditions. e.g. use a formula like
=(A1<$X$1)*(MOD(ROW(),2)=1)

there X1 is your specific test value as first condition and
=(A1<$X$1)*(MOD(ROW(),2)=0)
as second condition