Conditional formatting

NGrace

New Member
Joined
Oct 17, 2019
Messages
3
HI,

Newbie here, have formatted a table to grey out rows based on a condition on a column, but it has overridden my rag colouring, can anyone help? I have the if = to AR then format then this is for the lines - [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=$R10="Yes"[/FONT]
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Welcome to the Board!

but it has overridden my rag colouring
That is the way Conditional Formatting works. If the condition is met, it will override any manual formatting you have applied and apply the Conditional Formatting (if there is any direct conflict between the two, i.e. they hare both highlighting the cell).

So I am not sure what you want to happen.
 
Upvote 0
Yes.

If you wanted to exclude the 4th column, you could use this formula:
Code:
=AND($R10="Yes",COLUMN()<>4)
 
Last edited:
Upvote 0
Brilliant, thank you, what if i wanted to omit 2 columns?
Just keep adding more criteria to the AND statement, i.e. to exclude columns 2 and 4
Code:
=AND($R10="Yes",COLUMN()<>2,COLUMN()<>4)
You can keep going with this to exclude even more columns. Just follow the same pattern.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top