I have 2 cells that IF they DO NOT match numerically I want them to change fill color (a warning flag), I know it's done through conditional formatting but I can only find how to do it with matching cells. Any help would be appreciated.
I have 2 cells that IF they DO NOT match numerically I want them to change fill color (a warning flag), I know it's done through conditional formatting but I can only find how to do it with matching cells. Any help would be appreciated.
Which are the two cells? We can't give you a formula if we don't know which cells it should refer to. Attach a sample workbook (the FAQ describes how to).
Pete
Hi, welcome to the forum
1. highlight the range you want to apply the conditional formatting to (A1)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A1=B1
click on B1 and Repeat 3 and 4
Oviously adjust those ranges to suite
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
I have a SUM formula in I10 and a SUM formula in I13, when the sums in each DO NOT match I would like cells I10 and I13 to turn red.
Last edited by DanPop; 01-18-2016 at 03:15 PM.
Select cell I10, then click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the box:
=$I$10<>$I$12
Click the Format button | Fill tab and choose red, then click OK twice to exit. You can use the Format Painter icon to copy the format from I10 into I12 if you want both cells to show red.
Hope this helps.
Pete
oops *not match*, not *match*
Thanks Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks