Hi,
if have to do conditional formating. If there is value a4, highlight upto z4, if a4 has not value then dont highlight.
Its urgent. Pls help me out.
Regards,
raj.
Hi,
if have to do conditional formating. If there is value a4, highlight upto z4, if a4 has not value then dont highlight.
Its urgent. Pls help me out.
Regards,
raj.
Hi
select range a4:z4
then click conditional formatting > use a formula to determine which cells to format
enter this formula: =$A$4<>""
then click format > fill and select the colour you want
.. or copy from this file, if it's easier
Hi
In Conditional Formatting rules, put this.
=$A$4<>""
Choose color>> Range>>>A4:Z4>>>OK.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks