Conditional formatting

[4thorns]

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

 

[flyingdebris]

there is a number of ways. one quick way is to:
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!!!!!!!!!

 

[flyingdebris]

just to add...when the number is zero or above, B1 will return a typical white cell with a positive number. if you wanted a blank cell, just change the font colour to white as you normally would, and you will have a "blank cell". or add a new rule to change it to green or similar. have fun!!!

 

[4thorns]

Thanks for the reply. Perfect answer...Unfortunately I think I worded it wrong.
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

 

[flyingdebris]

I'm pretty sure conditional formatting still applies here. Sorry if im mistaken, but what you explained in your previous post still seems to be solved with my initial instruction. I must be misunderstanding you somewhere sorry.

 

[4thorns]

I've got it now. Thanks.

Doug