Conditional formatting
Conditional formatting
(OP)
Seems like this shouldn't be difficult but it must be bed time. Simply put...
Conditional format in cell B1....If A1 is less than zero then format text in this cell (B1) red.
Not sure how to go about this. Any thoughts?
Doug
Conditional format in cell B1....If A1 is less than zero then format text in this cell (B1) red.
Not sure how to go about this. Any thoughts?
Doug





RE: Conditional formatting
1. select B1, then choose conditional formatting
2. window pops up...select the top option "Highlight Cell rules"
3. window pops up...select "less than"
4. in next window, simply type 0 in the text box
5. then to the right of that is a drop down menu. select the bottom option "custom format"
6. change both the FONT and the FILL to red. Hit OK.
7. Hit OK again.
8. In B1 type, =A1
9. type in your number below zero.....
8. Success!!!!!!!!!
RE: Conditional formatting
RE: Conditional formatting
It should have read, if (A1) is less than zero then format (B1) red. Another way to put it would be if one cell is less than
zero then format a different one red. Would I maybe have to use a function in (B1) instead of conditional formatting?
Thanks again.
Doug
RE: Conditional formatting
RE: Conditional formatting
Doug