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

conditional formating excel column A based on value of column C -- for entire column

its seems I cannot get conditional formatting to work for an entire range

i want cells in column A to be colored red if their corresponding cells in in column C have a value

how can i do this besides creating a rule for every cell in column a
WANT a global rule for all of col A
0
finnstone
Asked:
finnstone
  • 2
2 Solutions
 
Farzad AkbarnejadCommented:
Hi,
The following link has a strait forward and short description help of your task.

http://office.microsoft.com/en-001/excel-help/use-a-formula-to-apply-conditional-formatting-HA102809768.aspx

-FA
0
 
finnstoneAuthor Commented:
no it doesnt
0
 
ProfessorJimJamCommented:
please find attached.  conditional formatting is set for you.
Book1.xlsx
0
 
Farzad AkbarnejadCommented:
select entire column A and use new rule and write formula as =$C1=[your value]

-FA
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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