Forum Discussion
Conditional format using an if then cell style
ie: if e4>g4 then cellstyle = good elseif e4=g4 then cellstyle = neutral else cellstyle = bad
Please help if you have any idea how to do this
3 Replies
- ANY EXAMPLES???????????????????
- Typing all caps is considered shouting and not very polite.
Format all cells with cell style bad.
Add a conditional format where e4>g4, cellstyle = good
Add another conditional format e4=g4, cellstyle = neutral
- You will have to add a separate conditional format for each condition.
