Conditional Formatting.JPG
In the attached workbook, I have applied the following conditional formatting rule to column F.
if $E:$E<>$F:$F format cell values Red
However, the entire column F is formatted Red even if the values in column E are equal to values in column F.
Request if someone could help resolve the issue.
Regards
Last edited by hiwire03; 12-01-2020 at 08:52 PM.
Edit the formula to =E1<>F1 and that should fix it for you.
When you select the whole column the active cell is E1 therefore you should cretae a formula which relates to E1, $$ are omitted to ensure that the formula changes to E2 E3 E4 so on within the range to check.
EDIT
Use =AND(E1<>F1,F1<>"Check") to stop the heading from changing to red fill.
Last edited by Harribone; 12-01-2020 at 11:13 AM.
Say thanks, click *
Your CF formula is checking the entire column. It should check only one cell. Change it to this:
Formula:
Please Login or Register to view this content.
On second look that will also highlight your header. If you don't want that, then this:
Formula:Please Login or Register to view this content.
Here is some information about conditional formatting and formulas.
Awesome! Works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks