I want to highlight or change the font color of a cell already containing an IF statement. For example, the formula which is working fine in F12 is =IF(E12=TRUE,A12, ""). And I want to say, IF(I12 >0, highlight F12). I know it it will be conditional formatting, but do I combine it with the statement in F12? If so, how should it be written? I need step-by-step help, if possible.
Thanks.
Hi and welcome to the forum
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =I12>0 format fill as required
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you, thank you, thank you, FDibbins! Your suggestion worked beautifully!! And I'm delighted with such a timely response.
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
I intended to mark it as solved, but made an error and marked as unsolved. Can't find option to mark as solved. Where is it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks