Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I shade cells using the "IF" function?
I am trying to shade a cell using the "IF" function. What code would I put
in the "Value if True" space in order for the function to shade the cell automatically? Anyone know how to do that, because I can't find it in "Help"? Thanks, Robert |
#2
|
|||
|
|||
Hi
formulas can't change cell formats. But have a look at 'Format - Conditional Format' to achieve your goal "Kaz" wrote: I am trying to shade a cell using the "IF" function. What code would I put in the "Value if True" space in order for the function to shade the cell automatically? Anyone know how to do that, because I can't find it in "Help"? Thanks, Robert |
#3
|
|||
|
|||
Use Conditional Formatting
"Kaz" wrote in message ... I am trying to shade a cell using the "IF" function. What code would I put in the "Value if True" space in order for the function to shade the cell automatically? Anyone know how to do that, because I can't find it in "Help"? Thanks, Robert |
#4
|
|||
|
|||
Hi,
Can you paste your formula in your message ?And are you using your formula in conditional formatting ? Regards Govind. Kaz wrote: I am trying to shade a cell using the "IF" function. What code would I put in the "Value if True" space in order for the function to shade the cell automatically? Anyone know how to do that, because I can't find it in "Help"? Thanks, Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
How do I automatically shade cells depending on data entered? | Excel Worksheet Functions | |||
How to shade a row of cells using conditional formatting | Excel Worksheet Functions |