• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

I need a formula that i can use with conditional formating

If a certain cel contains a value,  I want the cells in the same row to become yellow.
0
itbabe
Asked:
itbabe
1 Solution
 
byundtCommented:
=$A2<>""               'Note the absolute reference ($) to the column and relative reference to the row

The reference to row 2 in above formula should be to the top left cell in the range selected when you opened the Conditional Formatting menu item.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now