I need to create a rule or filter or whatever it's called to do the following:
If B1 value (Number) is NOT equal to F1 value (Number) then fill the whole row with color red.
How can I do that please?
I need to create a rule or filter or whatever it's called to do the following:
If B1 value (Number) is NOT equal to F1 value (Number) then fill the whole row with color red.
How can I do that please?
You could try doing it in conditional formatting or you can paste this in to the code page for the worksheeteverytime you select a cell the code will run, of course you can change it to work when the sheet calculates or move it to a command button or.....etc, just experiment with it!Please Login or Register to view this content.
Regards,
Simon
Highlight the whole of row 1, then select "Conditional Formatting..." from the Format menu. In the dialog box, change "Cell Value Is" to "Formula Is" and put "=$B1<>$F1" (without the quotes) into the box to the right, the click on "Format...", go to the Patterns tab and select the red block. Click OK, click OK again. Finally, copy the row, select the entire worksheet and do a Paste Special:Formats. Hey presto!
HTH
Col
If you give someone a program, you will frustrate them for a day; if you teach them how to program, you will frustrate them for a lifetime.
Thaaaaaaaaaaaaaanks, It worked and I appreciate your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks