Hallo!
I want, when cell D4 is equal to OK, some following rows (or a selection of cells-vertical and horizontal) to have a fill (eg. a pattern style)
However, there is a problem -> see the attached file.
Any help?
Hallo!
I want, when cell D4 is equal to OK, some following rows (or a selection of cells-vertical and horizontal) to have a fill (eg. a pattern style)
However, there is a problem -> see the attached file.
Any help?
Select the Cells which you want to format
then modify the formula in condition format to
=$D$4="OK"
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thanks!.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks