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
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
Format all cells with cell style bad.
Add a conditional format where e4>g4, cellstyle = good
Add another conditional format e4=g4, cellstyle = neutral