How do I change the fill color of a cell using an "IF" function
Hi,
At Fomats/Conditional Formatting - ConditonsFormulas Is Box, write the
formula as
Suppose you have data at A1 then
=A1<7
Then, click Format button set pattern colour as Red and click OK
You will get the desired thing.
Also, if you want to copy the same to all your sheet, Then copy A1, and
select the data. Paste special using right mouse button and select
Formats.
I hope this helps you
Thanks
Shail
donschap wrote:
I'm trying to change the fill color of a cell based on a condition (value)..
FOr example if a value is less than 7, fill the cell color in red
|