Solved How change color in a row as the color of the first cell

March 16, 2020 at 10:02:53
Specs: Windows 10
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?

See More: How change color in a row as the color of the first cell


#1
March 16, 2020 at 10:26:52
✔ Best Answer
If you really want every row on the sheet and the entire row 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


Report •
Related Solutions


Ask Question