Hello everybody
I need a conditional formatting rule (Just one rule)
It depends on cell B2 value .. If cell B2 value is Red then range("B5:E10") would be highlighted red
If cell B2 value is Bule then range("B5:E10") would be highlighted Blue ...
and so one
I have ten values and need to apply ten colours .. I can manage conditional formatting for each color
But I'm searching for a way to do that in one rule or using UDF function that achieve that task
I imagine something like that
and use this UDF function in Conditional formatting
But I have simple idea about colorindex colors and don't know if it is possible to use UDF function in conditional formatting rules or not
I used this rule
It is ok .. I have to double click in cell B2 to have my results.
I need to select a color from the list in B2 and got the desired color in my range at once
Bookmarks