I have a spreadsheet with about 10 rows of 20 cells. I would like to put conditional formating on each row to this affect:
If cell $b2=ProductX, then highlight the entire row blue.
Can someone help me do this? I saw someone do this without using VBA and just the stardard conditional formating menu a few weeks ago, but I cannot remember how he did it.
Kulata
If cell $b2=ProductX, then highlight the entire row blue.
Can someone help me do this? I saw someone do this without using VBA and just the stardard conditional formating menu a few weeks ago, but I cannot remember how he did it.
Kulata