I set the cells in column A to show different colors based on given values (no fill for values equal or over than 4; yellow for values between or equal to 0 and 3; red for values below 0). I would like that every single row is set up as the relevant cell (if cell A2 is red, the all row 2 has to be red). How can I do?

If you really want every row on the sheet and the entirerow to be formatted as you described, then the process below should work.If you only need this done within a certain range, say A1:BA1000, then select only that range before setting the following rules:

For the entire sheet-entire row, click the triangle about the Row numbers to select the entire sheet.

With the entire sheet selected, use Conditional Formatting with these formulas:

=$A1<0 ---> set Fill Color to Red

=AND($A1>=0,$A1<=3) ---> set Fill Color to Yellow

Keep in mind that any empty cell in Column A will cause that entire row to be Yellow because Excel considers an empty cell to be 0. You can force it to be Yellow only when there is actually a 0 in the cell with this:

=AND($A1<>"",$A1>=0,$A1<=3)

The key here is the $, which locks Column A as the only column that the Conditional Formatting rule will look at to determine if that row should be filled.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03

Ask Your Question

Weekly Poll