Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formmating
http://www.savefile.com/files/1872633
Dear Expert In the attached file in Column K i apply the Conditional Formatting. But in K19 and k30 will also shown the Red Font. I don't want to apply Conditional Formatting in the Header. Its just a Example i have more than 50 Sheets and around 3000 data in every file. Could you Please tell me What Formula can i use in CF will not apply on any Header of the Column Thanks Hardeep kanwar |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formmating
On Nov 5, 10:41*am, Hardeep_kanwar
wrote: http://www.savefile.com/files/1872633 Dear Expert In the attached file in Column K i apply the Conditional Formatting. But in K19 and k30 will also shown the Red Font. I don't want to apply Conditional Formatting *in the Header. Its just a Example i have more than 50 Sheets and around 3000 data in every file. Could you Please tell me What Formula can i use in CF will not apply on any Header of the Column Thanks Hardeep kanwar Just don't select the header cell when you do the conditional format. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formmating
You mean to say i have to apply CF in cell wise like
k8:k14 k20:k24 k31:34 One by One But as i say you that i have more than 50 sheets with 3000 thousand data Thanks In Advance hardeep kanwar "Spiky" wrote: On Nov 5, 10:41 am, Hardeep_kanwar wrote: http://www.savefile.com/files/1872633 Dear Expert In the attached file in Column K i apply the Conditional Formatting. But in K19 and k30 will also shown the Red Font. I don't want to apply Conditional Formatting in the Header. Its just a Example i have more than 50 Sheets and around 3000 data in every file. Could you Please tell me What Formula can i use in CF will not apply on any Header of the Column Thanks Hardeep kanwar Just don't select the header cell when you do the conditional format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formmating Help | Excel Worksheet Functions | |||
Conditional Formmating | Excel Worksheet Functions | |||
Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
conditional formmating data and put it into a graph... | Charts and Charting in Excel | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |