I need help with conditional formating.
I need Row 30 to change colour when D30 is equal to a certain value. At the moment i can only get the one cell to change colour
I need help with conditional formating.
I need Row 30 to change colour when D30 is equal to a certain value. At the moment i can only get the one cell to change colour
Select the entire row -> Conditional Formatting
Formula is =IF($D$30=<your value here>,1,0)
Hope this helps.
Originally Posted by smith.james0
Select the row. Enter:
CF1: Formula is =$D30 = "certain value"
Format1: Patterns/<changed color>
In article <[email protected]>,
smith.james0
<[email protected]> wrote:
> I need help with conditional formating.
>
> I need Row 30 to change colour when D30 is equal to a certain value. At
> the moment i can only get the one cell to change colour
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks